SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 42576: PC File Server generates "Failed to Connect to Server" message when the server name is longer than 32 characters

DetailsAboutRate It

When importing files using the PC File Server the following error can be generated:

ERROR: Failed to connect to the Server:Servername.ipaddress.longname.c  

The server name will be truncated in the message. The problem occurs when the server name is longer than 32 characters in the server parameter as shown below:

proc import dbms=excelcs out=work.test12 datafile='c:\mydir\test.xls' replace; port=8621; server='Servername.ipaddress.longname.com'; sheet='sheet1'; run;

To resolve the problem do one of the following:

  • Replace the server= name with the IP address rather than the actual servername
  • Use the second maintenance release of SAS 9.2 (TS2M2) or later where the server=parameter can be up to 255 characters.


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to PC FilesMicrosoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP49.2 TS2M2
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP49.2 TS2M2
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP49.2 TS2M2
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP49.2 TS2M2
64-bit Enabled AIX9.1 TS1M3 SP49.2 TS2M2
64-bit Enabled HP-UX9.1 TS1M3 SP49.2 TS2M2
64-bit Enabled Solaris9.1 TS1M3 SP49.2 TS2M2
HP-UX IPF9.1 TS1M3 SP49.2 TS2M2
Linux9.1 TS1M3 SP49.2 TS2M2
Linux on Itanium9.1 TS1M3 SP49.2 TS2M2
Solaris for x649.1 TS1M3 SP49.2 TS2M2
Tru64 UNIX9.1 TS1M3 SP49.2 TS2M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.